package com.tom;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class List {
	static MyConnection myConn;
	public static void main(String[] args) {
		//Connection conn = null;
		//PreparedStatement pstmt = null;
		Statement stmt;
		ResultSet rs;
		myConn = new MyConnection("MYSQL");
		try {
			stmt=myConn.getMyStatement();
			rs=stmt.executeQuery("select * from animals");
			
			while (rs.next()){
				System.out.println(rs.getString("a_id"));;
				//String a_id = rs.getString("a_id");
				//String p_id = rs.getString("p_id");
				//String m_userid = rs.getString("m_userid");
				
				//System.out.println( a_id+ "/" + p_id + "/" + m_userid);
				
				
				
				
				
				
				
				
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			System.out.println(e.getMessage());
		}
		
		
		
	}

}
